package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.Checkgroup;
import com.itheima.vo.CheckGroupVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


public interface CheckgroupMapper extends BaseMapper<Checkgroup> {
    @Select("select ct.* from setmeal_group_t st left join checkgroup_t ct on st.group_id=ct.id where st.setmeal_id = #{sId}")
    List<CheckGroupVo> findGroupsBysId(@Param("sId") Long sId);
}
